HydroTrek IoT Functions

The HydroTrek IoT Function that receives events from Azure Event Hub and inserts into PSQL Timeseries is running on the ORSANCO VM. The PSQL database is also on this VM.

Email 4/26/2023

Sudhir,

I'm going to summarize the latest status of the HydroTrek IoT Function and API so we can decide what's up next.

• Function
  • Currently runs fine as a local instance inside the ORSANCO VM. This successfully receives messages and inserts data using a direct PG connection to the local server.
  • It runs and receives messages when hosted in the cloud, HOWEVER, the insertion does not work from the cloud. We will need to finish one of the following implementations:
    • Direct pg connection over the internet; this will require setting up a Virtual network NAT gateway: Azure Functions IP Addresses
    • CRUD through hosted API. This will require finishing up the API and resolving any potential CORS issues...
• API
  • Currently runs fine locally on my development machine.
  • We need to finish the implementation to ensure we can POST whatever data will be required and GET any data for plotting. We will need to make sure we add whatever endpoints are required.
  • We will need to figure out how we plan on hosting the API and address any potential CORS related issues.

Alternatively, we can leave it running as it works now. Function on the VM, all connections direct to the PSQL Server on the VM, no API.

What are your thoughts?

Jake Specht Senior Software Architect

ORSANCO VM Process

TODO: Document this process. tmux and npm start.